package com.sdjzu.university.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sdjzu.university.entity.Professional;
import com.sdjzu.university.entity.University;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface ProfessionalMapper extends BaseMapper<Professional> {
    @Select("select * from Professional")
    List<Professional> selectList();

    @Insert("insert into Professional values ('艺术学类','130101','四年','艺术学学士')")
    int insert();

    @Update("update Professional set fixedYEAR = '四年' where professionalID = '120101'")
    int update();

    @Delete("delete from Professional where professionalID = '090101'")
    int delete();
}
